Breakdown Account Master (GL00100)

azurecurve Products Microsoft Dynamics GP (0)FinancialBreakdown Account Master (GL00100)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/GL00100

Product: Microsoft Dynamics GP (0)
Series: Financial

Display Name: Account Master
Physical Name: GL00100
Technical Name: GL_Account_MSTR

Group Display Name: Account Master
Group Technical Name: Account Master

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	ACTINDX	Account Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['Account Master'].ACTINDX AS 'Account Master-Account Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM GL00100 AS ['Account Master'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['Account Master'].ACTINDX = ['Account Index Master'].ACTINDX
2	ACTNUMBR	Account Number	Account_Number	Composite	80
3	ACTNUMBR_1	Account Number:Account_Segment_Pool1	String	Account_Segment_Pool1	6
4	ACTNUMBR_2	Account Number:Account_Segment_Pool2	String	Account_Segment_Pool2	6
5	ACTNUMBR_3	Account Number:Account_Segment_Pool3	String	Account_Segment_Pool3	6
6	ACTNUMBR_4	Account Number:Account_Segment_Pool4	String	Account_Segment_Pool4	6
7	ACTNUMBR_5	Account Number:Account_Segment_Pool5	String	Account_Segment_Pool5	6
8	ACTNUMBR_6	Account Number:Account_Segment_Pool6	String	Account_Segment_Pool6	6
9	ACTNUMBR_7	Account Number:Account_Segment_Pool7	String	Account_Segment_Pool7	6
10	ACTNUMBR_8	Account Number:Account_Segment_Pool8	String	Account_Segment_Pool8	6
11	ACTNUMBR_9	Account Number:Account_Segment_Pool9	String	Account_Segment_Pool9	6
12	ACTNUMBR_10	Account Number:Account_Segment_Pool10	String	Account_Segment_Pool10	6
13	ACTALIAS	Account Alias	String	STR20_Account_Alias	20
14	MNACSGMT	Main Account Segment	String	STR66_Seg_ID	66
15	ACCTTYPE	Account Type	Integer	DDL_Account_Type	0
	There are four types of account supported by Microsoft Dynamics GP. Click to show/hide Account Types 1 Posting Account 2 Unit Account 3 Posting Allocation Account 4 Unit Allocation Account
16	ACTDESCR	Account Description	String	STR50	50
17	PSTNGTYP	Posting Type	Integer	GB	0
	The Posting Type is the type of Posting Account. Click to show/hide Posting Types 0 Balance Sheet accounts have their balance brought forward to the next year during a Year-End Close. 1 Profit and Loss accounts have their balance closed to a retained earnings account during the Year-End Close.
18	ACCATNUM	Account Category Number	Integer	INT2_U0	2
	Key to the Account Category Master (GL00102). Click to show/hide SELECT ['Account Master'].ACCATNUM AS 'Account Master-Account Category Number' ,['Account Category Master'].ACCATNUM AS 'Account Category Master-Account Category Number' FROM GL00100 AS ['Account Master'] INNER JOIN GL00102 AS ['Account Category Master'] ON ['Account Master'].ACCATNUM = ['Account Category Master'].ACCATNUM
19	ACTIVE	Active	Boolean	CB_Active	0
20	TPCLBLNC	Typical Balance	Integer	GB	0
	The Typical Balance shows whether an account typically has a Debit or Credit Balance; used by reporting tools such as Management Reporter to determine how a balance is shown on financial statements. Click to show/hide Typical Balance 0 Debit 1 Credit
21	DECPLACS	Decimal Places	Integer	DDL_Decimal_Places	0
22	FXDORVAR	Fixed Or Variable	Integer	LB_Fixed_Or_Variable	0
23	BALFRCLC	Balance For Calculation	Integer	GB	0
24	DSPLKUPS	Display In Lookups	Long Integer	ML_Display_In_Lookups	0
25	CNVRMTHD	Conversion Method	Integer	DDL_Conversion_Method	0
26	HSTRCLRT	Historical Rate	Currency (Variable)	DLR14_Exchange_Rate	14
27	NOTEINDX	Note Index	Currency	DLR14	14
	Key to the Record Notes Master (SY03900). Click to show/hide SELECT ['Account Master'].NOTEINDX AS 'Account Master-Note Index' ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index' FROM GL00100 AS ['Account Master'] INNER JOIN SY03900 AS ['Record Notes Master'] ON ['Account Master'].NOTEINDX = ['Record Notes Master'].NOTEINDX
28	CREATDDT	Created Date	Date	DT	8
29	MODIFDT	Modified Date	Date	DT	8
30	USERDEF1	User Defined 1	String	STR20	20
31	USERDEF2	User Defined 2	String	STR20	20
32	PostSlsIn	Post Sales In	Integer	SumOrDetail	0
33	PostIvIn	Post Inventory In	Integer	SumOrDetail	0
34	PostPurchIn	Post Purchasing In	Integer	SumOrDetail	0
35	PostPRIn	Post Payroll In	Integer	SumOrDetail	0
36	ADJINFL	Adjust for Inflation	Boolean	CB_Adjust_For_Inflation	0
37	INFLAREV	Inflation Revenue Account Index	Long Integer	LI_14	14
38	INFLAEQU	Inflation Equity Account Index	Long Integer	LI_14	14
39	ACCTENTR	Allow Account Entry	Boolean	CB_Allow_Account_Entry	0
	When unmarked, this flag allows accounts to be locked down by preventing users from posting to the account, while still allowing it to default onto transactions. Typically this is done on control accounts which should never have manual postings made to them.
40	USRDEFS1	User Defined String 1	String	STR30	30
41	USRDEFS2	User Defined String 2	String	STR30	30
42	Clear_Balance	Clear Balance	Boolean	Clear Balance	0
43	Workflow_Status	Workflow Status	Integer	Workflow Status	0

azurecurve Products Microsoft Dynamics GP (0)FinancialBreakdown Account Master (GL00100)

Click to show/hide

Click to show/hide Account Types

Click to show/hide Posting Types

Click to show/hide

Click to show/hide Typical Balance

Click to show/hide

Leave a Reply Cancel reply